﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetBienByNombre')
	BEGIN
		DROP  Procedure  GetBienByNombre
	END

GO

CREATE Procedure GetBienByNombre

	(
		@nombre nvarchar(50)
	)

AS

begin
	SELECT
	[Descripcion],
	[Estado],
	[IdBien],
	[IdUnidadMedida],
	[Nombre],
	[Precio],
	[StockActual],
	[StockMinimo]
	FROM [Bien] 
	WHERE [Nombre]= @nombre
end

GO


GRANT EXEC ON GetBienByNombre TO PUBLIC

GO

